Problem Note 39321: PROC MEANS, SUMMARY, or TABULATE might report incorrect _FREQ_ values when the THREADS and NOTRAP options are specified
 |  |  |  |  |  |
The MEANS, SUMMARY, or TABULATE procedure might report incorrect values of the automatic output data set variable _FREQ_ when the procedure statement options THREADS and NOTRAP are specified. The _FREQ_ values might be incorrectly doubled. This problem is most likely to occur when a significant number of analysis variables are requested.
To circumvent the problem, remove either the THREADS or the NOTRAP option from the procedure statement.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | OpenVMS Alpha | 9 TS M0 | 9.2 TS2M3 |
| 64-bit Enabled AIX | 9 TS M0 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 9 TS M0 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 9 TS M0 | 9.2 TS2M3 | ||
| HP-UX IPF | 9 TS M0 | 9.2 TS2M3 | ||
| Linux | 9 TS M0 | 9.2 TS2M3 | ||
| Tru64 UNIX | 9 TS M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9 TS M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9 TS M0 | 9.2 TS2M3 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9 TS M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9 TS M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9 TS M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9 TS M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9 TS M0 | 9.2 TS2M3 | ||
| Microsoft Windows NT Workstation | 9 TS M0 | |||
| Microsoft Windows 2000 Professional | 9 TS M0 | |||
| Microsoft Windows 2000 Server | 9 TS M0 | |||
| Microsoft Windows 2000 Datacenter Server | 9 TS M0 | |||
| Microsoft Windows 2000 Advanced Server | 9 TS M0 | |||
| z/OS | 9 TS M0 | 9.2 TS2M3 | ||
When the MEANS, SUMMARY, or TABULATE procedure statement options THREADS and NOTRAP are set with a significant number of analysis variables requested, the automatic output data set variable _FREQ_ might be incorrectly doubled. The code below replicates the problem.
data test;
array av[100];
do i = 1 to 1e5;
cv1 = int( ranuni( 123 ) * 2);
do j = 1 to 100 ;
av[j] = rannor( 456 ) * 100;
end;
drop i j;
output;
end;
run;
proc summary data=test missing nway notrap threads;
class cv1;
var av1-av35;
output out=test2 n= sum= mean= / autoname;
run;
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#039321A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#039321
When the MEANS, SUMMARY, or TABULATE procedure statement options THREADS and NOTRAP are set with a significant number of analysis variables requested, the automatic output data set variable _FREQ_ might be incorrectly doubled.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2010-04-19 10:20:25 |
| Date Created: | 2010-04-12 08:50:07 |